﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[ClearAll]
	
AS
BEGIN
    delete from SQLAgentJobDetails    
	DELETE FROM [IndexColumn]	
	DELETE FROM [Index]	
	DELETE FROM [Column]	
	DELETE FROM [Table]	
	DELETE FROM [DatabaseFile]
	DELETE FROM [DatabaseUserRole]
	DELETE FROM [DatabaseUser]
	DELETE FROM [Database]
	DELETE FROM [ServerDrive]
	DELETE FROM [LoginServerRole]
	DELETE FROM [Login]
	DELETE FROM [ServiceSetting]
	DELETE FROM [Service]
	DELETE FROM [Server]
	DELETE FROM [Issue]

END
